'Declaration
 
Public Overloads Overrides Function Evaluate( _
   ByVal args() As System.Object _
) As System.Object

'Usage
 
Dim instance As CalcVLookupFunction
Dim args() As System.Object
Dim value As System.Object
 
value = instance.Evaluate(args)

public override System.object Evaluate( 
   System.object[] args
)

Parameters

args

The args contains 3 - 4 items: lookup_value, table_array, col_index_num, [range_lookup].

Lookup_value is the value to be found in the first row of the table. Lookup_value can be a value, a reference, or a text string.

Table_array is a table of information in which data is looked up. Use a reference to a range or a range name.

Col_index_num The column number in table_array from which the matching value must be returned.

[Range_lookup] is a logical value that specifies whether you want HLOOKUP to find an exact match or an approximate match.

Return Value

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

CalcVLookupFunction Class
CalcVLookupFunction Members
Overload List